alter database rename

Yesterday at the customer did an Rman machine recovery, the production library to get a copy of the test library, the total library is about 80G, a total of 2 hours, the customer's environment is Windows 11.2.0.3, this morning in Linux under another

Yesterday at the customer did an Rman recovery, the production library to get a copy to the test library, the total library of about 80G, a total of 2 hours, when the customer's environment is Windows 11.2.0.3, this morning under Linux re-test a bit,

1. View tablespace correspondence D:CD D:\app\administrator\product\11.2.0\dbhome_1\BINsqlplus sys/[email protected] as Sysdbaselect * FROM V$TABLESPACE;2. Close the database shutdown immediate; 3. Copy the data file to the new location  4. Start

Step 1 of ORACLE data migration from the CQ back-end database of the mobile development management system to the ex300array objective: Oracle programs are stored on the local hard disk (disk D) and data is stored on the ex300disk array (Disk Y ),

Migrating an Oracle database using Rman's level0 backup file-incomplete recovery-20160811Migrating an Oracle database from one machine A to another machine B (same as Linux platform), set to a different path, different instance nameSOURCE

Rman Machine Recovery considerations:1. When the RMAN machine recovers, the db_name must be the same. If you want to change to another instance name, you can modify it with the NID command after the recovery is successful. The instance name

1. Create the following directory:MKDIR-PV $ORACLE _base/admin/$ORACLE _sid/{{a,b,c,dp,u}dump,pfile}MKDIR-PV $ORACLE _base/flash_recovery_area 2. Create a oracle10g

All data files of the local disk need to be moved to storage.Summary of steps:1.shut Immediate Stop Library2.host CP dbfile to New Path3. Modify the position of the controlfile in the parameter to boot the database to mount4.rename Related Documents5

Previously wrote an article by modifying the control file to modify the path of the problem, now use method two through rename to modify the path of the problemExperimental object: Two Linux stand-alone Oracle 12C databases (both large and small

Windows XP oracle9.2.0.1.0sid: The test database is installed on disk D. Now, the control files, database files, log files, and temporary files under D: ORACLEORADATATEST are moved to F: TEST. First, close the database and copy the files under D:

Move the redo file path, the default redo log file path is the same as the Archivelog path, in the flashback area, because the flash back zone has a size limit, so redo log and archive log, especially archive log, will burst into the flashback zone.

There are several ways to migrate a database, and the more common is to use Rman to migrate. Using Rman to migrate a database belongs to the physical backup and Recovery category of the database, and the information about the database is completely

ASM management-how to rename diskgroup The new diskgroup rename function is added in ASM 11.2.0.1. You can use the renamedg command to rename the created diskgroup. Before renaming, you must first dismount diskgroup. If the renamed diskgroup is

Recently in the case of a bank database migration and escalation, as the system for the statistical run batch, the original system configuration has been unable to meet the performance requirements of running batches, it is required to buy new

This article describes how to build a Acfs file system on a virtual machine that already has 12c RAC installed, and use the ACFS snapshot to brush a cow (Copy-On-Write) library to do the test library. Highlight Step: Add ASM disk to virtual

Renamedatafile reports error ORA-01511, ORA-01121, ORA-01110 Rename datafile reports error ORA-01511, ORA-01121, ORA-01110 Symptom:After the instance is started to mount, rename datafile reports an error ORA-01511, ORA-01121, ORA-01110SQL>SQL>

Transfer Process:1. log on to sqlplus first: C:/Documents and Settings/jbdu> sqlplus "/As sysdba"2. Change the tablespace to offline: SQL> alter tablespace users offline;3. Copy tablespace files

Transfer An oracle Data File "*. dbf" Transfer Process:1. log on to sqlplus: C:/Documents and Settings/jbdu> sqlplus "/as sysdba" 2. change the tablespace to Offline: www.2cto.com SQL> alter tablespace users offline; 3. copy tablespace file copy

Nothing special, just keep track the history. C: \ Users \ Administrator> tnspic'Tnspic 'is not recognized as an internal or external command,Operable program or batch file. C: \ Users \ Administrator> tnsping orcl TNS Ping utility for 64-bit

First, back up the original libraryRun{backup database format '/home/oracle/backup/db_%u_%t.bak '; backup current controlfile format '/home/oracle/backup/ Ctl_%u_%t.bak '; backup spfile format '/home/oracle/backup/spfile_%u_%t.bak '; backup